Tabela WMPTYPE

Definicja tabeli WMPTYPE

Name

WMPTYPE

Code

WMPTYPE

Comment

Typ WMP


Lista kolumn tabeli WMPTYPE

Name

Code

WMPTYPEID

WMPTYPEID

ACTIVE

ACTIVE

CODE

CODE

WmpGroupId

WmpGroupId

NAME

NAME

PRICE

PRICE

WMPORDINANCEID

WMPORDINANCEID

WMPPROFILEID

WMPPROFILEID


Kolumna WMPTYPEID tabeli WMPTYPE

Definicja kolumny WMPTYPEID tabeli WMPTYPE

Name

WMPTYPEID

Code

WMPTYPEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator typu


Kolumna ACTIVE tabeli WMPTYPE

Definicja kolumny ACTIVE tabeli WMPTYPE

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(3)

Mandatory

No

Comment

informacja czy typ jest aktywny


Kolumna CODE tabeli WMPTYPE

Definicja kolumny CODE tabeli WMPTYPE

Name

CODE

Code

CODE

Data Type

VARCHAR2(255)

Mandatory

No

Comment

kod


Kolumna WmpGroupId tabeli WMPTYPE

Definicja kolumny WmpGroupId tabeli WMPTYPE

Name

WmpGroupId

Code

WmpGroupId

Data Type

NUMBER(10)

Mandatory

No

Comment

numer grupy


Kolumna NAME tabeli WMPTYPE

Definicja kolumny NAME tabeli WMPTYPE

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

nazwa


Kolumna PRICE tabeli WMPTYPE

Definicja kolumny PRICE tabeli WMPTYPE

Name

PRICE

Code

PRICE

Data Type

NUMBER(19,2)

Mandatory

No

Comment

normatyw


Kolumna WMPORDINANCEID tabeli WMPTYPE

Definicja kolumny WMPORDINANCEID tabeli WMPTYPE

Name

WMPORDINANCEID

Code

WMPORDINANCEID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator rozporzadzenia


Kolumna WMPPROFILEID tabeli WMPTYPE

Definicja kolumny WMPPROFILEID tabeli WMPTYPE

Name

WMPPROFILEID

Code

WMPPROFILEID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator proflu


Lista kluczy tabeli WMPTYPE

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WMPTYPE

Definicja klucza Identifier_1 tabeli WMPTYPE

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment